Skip to main content  


@Middle Function Returns Characters when Offset Is Negative

Technote Number: 1116590

This issue was reported to Lotus Software Quality Engineering, and was
addressed in these Notes Client releases: 6.0.1 CF3, 6.0.2 CF2 and 6.0.3.

Excerpt from the Lotus Notes and Domino Release 6.0.1 CF3, 6.0.2 CF2 and 6.0.3
MR fix lists (available at http://www.lotus.com/ldd):

SPR# MCHG5DTENB - In R4/R5, when the offset parameter of the @Middle formula is
a negative number, a blank string is correctly returned. In R6 the offset
counts from "right to left" and returns the number of characters designated by
the last parameter - fixed this problem such that a blank string is returned in
R6 also. This regression was introduced in 6.0 and fixed in 6.0.3, 6.0.2 CF2,
and 6.0.1 CF3.

Check to see if the offset is negative prior to calling @Middle. For example:

@If(offset<0;"";@Middle(inputstring, offset, numberofchars))

Related document:
@Middle and @MiddleBack Return an Empty String if Substring Is not Found
Document #: 1104692
More >

  Document options
Print this document
Print view

Search Advanced Search

  Fix list views

 RSS feeds   RSS
Subscribe to the fix list

Using this database
View notices

  HCL Support
HCL Support

    About HCL Privacy Contact